﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Show.aspx.cs" Inherits="Demo.Show1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>管理员看到的信息</title>
    <style type="text/css">
        .auto-style1 {
            width: 100%;
        }
        .auto-style2 {
            height: 22px;
        }
        .auto-style3 {
            height: 157px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
  

        <table  class="auto-style1">
            <tr>
                <td>&nbsp;<asp:Label ID="Label2" runat="server" Font-Bold="True" Text="Teacher表"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="auto-style3">
                    <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4" Width="500px" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="TeacherID" DataSourceID="SqlDataSource1">
                        <Columns>
                            <asp:BoundField DataField="TeacherID" HeaderText="TeacherID" InsertVisible="False" ReadOnly="True" SortExpression="TeacherID" />
                            <asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
                            <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                            <asp:BoundField DataField="TeacherName" HeaderText="TeacherName" SortExpression="TeacherName" />
                            <asp:CommandField ShowEditButton="True" />
                            <asp:CommandField ShowDeleteButton="True" />
                        </Columns>
                        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
                        <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
                        <RowStyle BackColor="White" ForeColor="#330099" />
                        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                        <SortedAscendingCellStyle BackColor="#FEFCEB" />
                        <SortedAscendingHeaderStyle BackColor="#AF0101" />
                        <SortedDescendingCellStyle BackColor="#F6F0C0" />
                        <SortedDescendingHeaderStyle BackColor="#7E0000" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DataConnectionString3 %>" DeleteCommand="DELETE FROM [TeacherList] WHERE [TeacherID] = @TeacherID" InsertCommand="INSERT INTO [TeacherList] ([UserName], [Password], [TeacherName]) VALUES (@UserName, @Password, @TeacherName)" SelectCommand="SELECT * FROM [TeacherList]" UpdateCommand="UPDATE [TeacherList] SET [UserName] = @UserName, [Password] = @Password, [TeacherName] = @TeacherName WHERE [TeacherID] = @TeacherID">
                        <DeleteParameters>
                            <asp:Parameter Name="TeacherID" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="UserName" Type="String" />
                            <asp:Parameter Name="Password" Type="String" />
                            <asp:Parameter Name="TeacherName" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="UserName" Type="String" />
                            <asp:Parameter Name="Password" Type="String" />
                            <asp:Parameter Name="TeacherName" Type="String" />
                            <asp:Parameter Name="TeacherID" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td class="auto-style2">&nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style2">&nbsp;<asp:Label ID="Label1" runat="server" Font-Bold="True" Text="Student 成绩表"></asp:Label>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView2" runat="server" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" Width="500px" AutoGenerateColumns="False" DataKeyNames="GradeID" DataSourceID="SqlDataSource2">
                        <Columns>
                            <asp:BoundField DataField="GradeID" HeaderText="GradeID" InsertVisible="False" ReadOnly="True" SortExpression="GradeID" />
                            <asp:BoundField DataField="TimeID" HeaderText="TimeID" SortExpression="TimeID" />
                            <asp:BoundField DataField="StudentID" HeaderText="StudentID" SortExpression="StudentID" />
                            <asp:BoundField DataField="Grade" HeaderText="Grade" SortExpression="Grade" />
                            <asp:BoundField DataField="CourseID" HeaderText="CourseID" SortExpression="CourseID" />
                            <asp:BoundField DataField="BusyworkName" HeaderText="BusyworkName" SortExpression="BusyworkName" />
                            <asp:CommandField ShowEditButton="True" />
                            <asp:CommandField ShowDeleteButton="True" />
                        </Columns>
                        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
                        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
                        <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
                        <RowStyle BackColor="White" ForeColor="#003399" />
                        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
                        <SortedAscendingCellStyle BackColor="#EDF6F6" />
                        <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
                        <SortedDescendingCellStyle BackColor="#D6DFDF" />
                        <SortedDescendingHeaderStyle BackColor="#002876" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:DataConnectionString3 %>" DeleteCommand="DELETE FROM [GradeList] WHERE [GradeID] = @GradeID" InsertCommand="INSERT INTO [GradeList] ([TimeID], [StudentID], [Grade], [CourseID], [BusyworkName]) VALUES (@TimeID, @StudentID, @Grade, @CourseID, @BusyworkName)" SelectCommand="SELECT * FROM [GradeList]" UpdateCommand="UPDATE [GradeList] SET [TimeID] = @TimeID, [StudentID] = @StudentID, [Grade] = @Grade, [CourseID] = @CourseID, [BusyworkName] = @BusyworkName WHERE [GradeID] = @GradeID">
                        <DeleteParameters>
                            <asp:Parameter Name="GradeID" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="TimeID" Type="Int32" />
                            <asp:Parameter Name="StudentID" Type="Int32" />
                            <asp:Parameter Name="Grade" Type="Decimal" />
                            <asp:Parameter Name="CourseID" Type="Int32" />
                            <asp:Parameter Name="BusyworkName" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="TimeID" Type="Int32" />
                            <asp:Parameter Name="StudentID" Type="Int32" />
                            <asp:Parameter Name="Grade" Type="Decimal" />
                            <asp:Parameter Name="CourseID" Type="Int32" />
                            <asp:Parameter Name="BusyworkName" Type="String" />
                            <asp:Parameter Name="GradeID" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label3" runat="server" Font-Bold="True" Text="学生表"></asp:Label>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView3" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Width="500px" AutoGenerateColumns="False" DataKeyNames="StudentID" DataSourceID="SqlDataSource4">
                        <AlternatingRowStyle BackColor="White" />
                        <Columns>
                            <asp:BoundField DataField="StudentID" HeaderText="StudentID" InsertVisible="False" ReadOnly="True" SortExpression="StudentID" />
                            <asp:BoundField DataField="SequenceNumber" HeaderText="SequenceNumber" SortExpression="SequenceNumber" />
                            <asp:BoundField DataField="Number" HeaderText="Number" SortExpression="Number" />
                            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                            <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
                            <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                            <asp:BoundField DataField="TeacherID" HeaderText="TeacherID" SortExpression="TeacherID" />
                            <asp:CommandField ShowEditButton="True" />
                            <asp:CommandField ShowDeleteButton="True" />
                        </Columns>
                        <EditRowStyle BackColor="#7C6F57" />
                        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                        <RowStyle BackColor="#E3EAEB" />
                        <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                        <SortedAscendingCellStyle BackColor="#F8FAFA" />
                        <SortedAscendingHeaderStyle BackColor="#246B61" />
                        <SortedDescendingCellStyle BackColor="#D4DFE1" />
                        <SortedDescendingHeaderStyle BackColor="#15524A" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:DataConnectionString3 %>" DeleteCommand="DELETE FROM [StudentList] WHERE [StudentID] = @StudentID" InsertCommand="INSERT INTO [StudentList] ([SequenceNumber], [Number], [Name], [Class], [Password], [TeacherID]) VALUES (@SequenceNumber, @Number, @Name, @Class, @Password, @TeacherID)" SelectCommand="SELECT * FROM [StudentList]" UpdateCommand="UPDATE [StudentList] SET [SequenceNumber] = @SequenceNumber, [Number] = @Number, [Name] = @Name, [Class] = @Class, [Password] = @Password, [TeacherID] = @TeacherID WHERE [StudentID] = @StudentID">
                        <DeleteParameters>
                            <asp:Parameter Name="StudentID" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="SequenceNumber" Type="String" />
                            <asp:Parameter Name="Number" Type="String" />
                            <asp:Parameter Name="Name" Type="String" />
                            <asp:Parameter Name="Class" Type="String" />
                            <asp:Parameter Name="Password" Type="String" />
                            <asp:Parameter Name="TeacherID" Type="Int32" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="SequenceNumber" Type="String" />
                            <asp:Parameter Name="Number" Type="String" />
                            <asp:Parameter Name="Name" Type="String" />
                            <asp:Parameter Name="Class" Type="String" />
                            <asp:Parameter Name="Password" Type="String" />
                            <asp:Parameter Name="TeacherID" Type="Int32" />
                            <asp:Parameter Name="StudentID" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server"></asp:SqlDataSource>
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
